FormattedValue Property

       

Indicates the formatted display of a cell value.

Return Values

Returns a String and is read-only.

Remarks

Use the FormattedValue property to obtain the formatted display value of the Value property of a Cell object. For example, if the value of a cell was 1056.87, and this value represented a dollar amount, FormattedValue would be $1,056.87.